{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8a8de553",
   "metadata": {},
   "source": [
    "# UCS citation data from Overton: Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aa6a1fa7",
   "metadata": {},
   "source": [
    "## Setting up the program"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "47a20653",
   "metadata": {},
   "source": [
    "Currently importing a lot of libraries because I don't know which ones I'll be using in the final program. Probably pandas and matplotlib. ucs_data contains the export of UCS reports from Presto, i.e. a DataFrame of all the articles published by UCS authors. cite_data (should be) a list of the citations in documents that cite UCS. Crucially, this includes citations of NON-UCS documents, so needs to be filtered by DOIs.\n",
    "\n",
    "To do: filter cite_data by the DOIs in ucs_data, add UCS programs to cite_data so we can categorize citations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6ac149fa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Citing document identifier</th>\n",
       "      <th>Source of citing document</th>\n",
       "      <th>Source type of citing document</th>\n",
       "      <th>Source subtype of citing document</th>\n",
       "      <th>Source country of citing document</th>\n",
       "      <th>Published on date of citing document</th>\n",
       "      <th>Title of citing document</th>\n",
       "      <th>Type of citation</th>\n",
       "      <th>Cited identifier</th>\n",
       "      <th>Cited title</th>\n",
       "      <th>Cited source or journal</th>\n",
       "      <th>Cited source type</th>\n",
       "      <th>Cited source subtype</th>\n",
       "      <th>Cited source country</th>\n",
       "      <th>Cited published on date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>gpogov-15f5258261ce008032012c9d1709dbb8</td>\n",
       "      <td>Government Publishing Office (GPO)</td>\n",
       "      <td>government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>42482</td>\n",
       "      <td>The impacts of climate change on human health ...</td>\n",
       "      <td>policy</td>\n",
       "      <td>ipcc-1e0b1a7ef1718ff08c682ce4cb651d90</td>\n",
       "      <td>AR5 Climate Change 2013: The Physical Science ...</td>\n",
       "      <td>IPCC</td>\n",
       "      <td>igo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IGO</td>\n",
       "      <td>41518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>gpogov-15f5258261ce008032012c9d1709dbb8</td>\n",
       "      <td>Government Publishing Office (GPO)</td>\n",
       "      <td>government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>42482</td>\n",
       "      <td>The impacts of climate change on human health ...</td>\n",
       "      <td>policy</td>\n",
       "      <td>pewresearch-5aeeea3f4648130cca833dd17c69075b</td>\n",
       "      <td>U.S. Population Projections: 2005-2050</td>\n",
       "      <td>Pew Research</td>\n",
       "      <td>think tank</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>39489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>gpogov-15f5258261ce008032012c9d1709dbb8</td>\n",
       "      <td>Government Publishing Office (GPO)</td>\n",
       "      <td>government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>42482</td>\n",
       "      <td>The impacts of climate change on human health ...</td>\n",
       "      <td>policy</td>\n",
       "      <td>ipcc-fa957a7cfe7a4a87f1522afb3e152e34</td>\n",
       "      <td>AR5 Climate Change 2014: Impacts, Adaptation, ...</td>\n",
       "      <td>IPCC</td>\n",
       "      <td>igo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IGO</td>\n",
       "      <td>41699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>gpogov-15f5258261ce008032012c9d1709dbb8</td>\n",
       "      <td>Government Publishing Office (GPO)</td>\n",
       "      <td>government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>42482</td>\n",
       "      <td>The impacts of climate change on human health ...</td>\n",
       "      <td>policy</td>\n",
       "      <td>ipcc-e7c472c0bc263a6d9aae17cb4f95adb5</td>\n",
       "      <td>Managing the Risks of Extreme Events and Disas...</td>\n",
       "      <td>IPCC</td>\n",
       "      <td>igo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IGO</td>\n",
       "      <td>40969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>gpogov-15f5258261ce008032012c9d1709dbb8</td>\n",
       "      <td>Government Publishing Office (GPO)</td>\n",
       "      <td>government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>42482</td>\n",
       "      <td>The impacts of climate change on human health ...</td>\n",
       "      <td>policy</td>\n",
       "      <td>pewresearch-80bcecbc8957c3ab5f967a9bf65ebdfb</td>\n",
       "      <td>Unauthorized Immigrant Population: National an...</td>\n",
       "      <td>Pew Research</td>\n",
       "      <td>think tank</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>40575</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Citing document identifier  \\\n",
       "0  gpogov-15f5258261ce008032012c9d1709dbb8   \n",
       "1  gpogov-15f5258261ce008032012c9d1709dbb8   \n",
       "2  gpogov-15f5258261ce008032012c9d1709dbb8   \n",
       "3  gpogov-15f5258261ce008032012c9d1709dbb8   \n",
       "4  gpogov-15f5258261ce008032012c9d1709dbb8   \n",
       "\n",
       "            Source of citing document Source type of citing document  \\\n",
       "0  Government Publishing Office (GPO)                     government   \n",
       "1  Government Publishing Office (GPO)                     government   \n",
       "2  Government Publishing Office (GPO)                     government   \n",
       "3  Government Publishing Office (GPO)                     government   \n",
       "4  Government Publishing Office (GPO)                     government   \n",
       "\n",
       "  Source subtype of citing document Source country of citing document  \\\n",
       "0                               NaN                               USA   \n",
       "1                               NaN                               USA   \n",
       "2                               NaN                               USA   \n",
       "3                               NaN                               USA   \n",
       "4                               NaN                               USA   \n",
       "\n",
       "   Published on date of citing document  \\\n",
       "0                                 42482   \n",
       "1                                 42482   \n",
       "2                                 42482   \n",
       "3                                 42482   \n",
       "4                                 42482   \n",
       "\n",
       "                            Title of citing document Type of citation  \\\n",
       "0  The impacts of climate change on human health ...           policy   \n",
       "1  The impacts of climate change on human health ...           policy   \n",
       "2  The impacts of climate change on human health ...           policy   \n",
       "3  The impacts of climate change on human health ...           policy   \n",
       "4  The impacts of climate change on human health ...           policy   \n",
       "\n",
       "                               Cited identifier  \\\n",
       "0         ipcc-1e0b1a7ef1718ff08c682ce4cb651d90   \n",
       "1  pewresearch-5aeeea3f4648130cca833dd17c69075b   \n",
       "2         ipcc-fa957a7cfe7a4a87f1522afb3e152e34   \n",
       "3         ipcc-e7c472c0bc263a6d9aae17cb4f95adb5   \n",
       "4  pewresearch-80bcecbc8957c3ab5f967a9bf65ebdfb   \n",
       "\n",
       "                                         Cited title Cited source or journal  \\\n",
       "0  AR5 Climate Change 2013: The Physical Science ...                    IPCC   \n",
       "1             U.S. Population Projections: 2005-2050            Pew Research   \n",
       "2  AR5 Climate Change 2014: Impacts, Adaptation, ...                    IPCC   \n",
       "3  Managing the Risks of Extreme Events and Disas...                    IPCC   \n",
       "4  Unauthorized Immigrant Population: National an...            Pew Research   \n",
       "\n",
       "  Cited source type Cited source subtype Cited source country  \\\n",
       "0               igo                  NaN                  IGO   \n",
       "1        think tank                  NaN                  USA   \n",
       "2               igo                  NaN                  IGO   \n",
       "3               igo                  NaN                  IGO   \n",
       "4        think tank                  NaN                  USA   \n",
       "\n",
       "  Cited published on date  \n",
       "0                   41518  \n",
       "1                   39489  \n",
       "2                   41699  \n",
       "3                   40969  \n",
       "4                   40575  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import csv\n",
    "import pandas as pd\n",
    "import matplotlib as plt\n",
    "\n",
    "ucs_data = pd.read_csv('UCS-articles-overton.csv') #CSV of UCS DOIs in Overton\n",
    "cite_raw = pd.read_csv('Citations-USA.csv') #CSV of citations in documents that cite UCS, filtered to USA pubs\n",
    "\n",
    "ucs_doi = ucs_data['DOI'].tolist() #Make list of DOIs of UCS pubs\n",
    "\n",
    "cite_raw.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "02f9303e",
   "metadata": {},
   "outputs": [],
   "source": [
    "ucs_filter = cite_raw['Cited identifier'].isin(ucs_doi) #Create filter to get only citations of UCS pubs\n",
    "\n",
    "ucs_cites = cite_raw[ucs_filter] #Apply filter to citation dataframe\n",
    "\n",
    "ucs_cites.to_csv('UCS-cites-in-overton.csv') #Save filtered dataframe to CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e9b362ab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Author</th>\n",
       "      <th>Date</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Keyword</th>\n",
       "      <th>DOI</th>\n",
       "      <th>Program</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cultivating control: Corporate lobbying on the...</td>\n",
       "      <td>Goswami, Omanjana. | Stillerman, Karen Perry.</td>\n",
       "      <td>5/13/2024</td>\n",
       "      <td>Agriculture. | Lobbying--United States.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doi.org/10.47923/2024.15464</td>\n",
       "      <td>Food &amp; Environment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Waste deep: How Tyson Foods pollutes US waterw...</td>\n",
       "      <td>Goswami, Omanjana. | Woods, Stacy.</td>\n",
       "      <td>4/30/2024</td>\n",
       "      <td>Meat industry and trade. | Water quality.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doi.org/10.47923/2024.15384</td>\n",
       "      <td>Food &amp; Environment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gas malfunction: Calling into question the rel...</td>\n",
       "      <td>Arbaje, Paul. | Specht, Mark.</td>\n",
       "      <td>1/9/2024</td>\n",
       "      <td>Gas power plants. | Natural gas.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doi.org/10.47923/2024.15312</td>\n",
       "      <td>Climate &amp; Energy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gas malfunction: Calling into question the rel...</td>\n",
       "      <td>Arbaje, Paul. | Specht, Mark.</td>\n",
       "      <td>1/9/2024</td>\n",
       "      <td>Gas power plants. | Natural gas.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doi.org/10.47923/2024.15312</td>\n",
       "      <td>Climate &amp; Energy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hydrogen-powered heavy-duty trucks: A review o...</td>\n",
       "      <td>Wilson, Sam.</td>\n",
       "      <td>23-Nov</td>\n",
       "      <td>Alternative fuel vehicles. | Hydrogen as fuel....</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://doi.org/10.47923/2023.15274</td>\n",
       "      <td>Clean Transportation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Title  \\\n",
       "0  Cultivating control: Corporate lobbying on the...   \n",
       "1  Waste deep: How Tyson Foods pollutes US waterw...   \n",
       "2  Gas malfunction: Calling into question the rel...   \n",
       "3  Gas malfunction: Calling into question the rel...   \n",
       "4  Hydrogen-powered heavy-duty trucks: A review o...   \n",
       "\n",
       "                                          Author       Date  \\\n",
       "0  Goswami, Omanjana. | Stillerman, Karen Perry.  5/13/2024   \n",
       "1             Goswami, Omanjana. | Woods, Stacy.  4/30/2024   \n",
       "2                  Arbaje, Paul. | Specht, Mark.   1/9/2024   \n",
       "3                  Arbaje, Paul. | Specht, Mark.   1/9/2024   \n",
       "4                                   Wilson, Sam.     23-Nov   \n",
       "\n",
       "                                             Subject Keyword  \\\n",
       "0            Agriculture. | Lobbying--United States.     NaN   \n",
       "1          Meat industry and trade. | Water quality.     NaN   \n",
       "2                   Gas power plants. | Natural gas.     NaN   \n",
       "3                   Gas power plants. | Natural gas.     NaN   \n",
       "4  Alternative fuel vehicles. | Hydrogen as fuel....     NaN   \n",
       "\n",
       "                                   DOI               Program  \n",
       "0  https://doi.org/10.47923/2024.15464    Food & Environment  \n",
       "1  https://doi.org/10.47923/2024.15384    Food & Environment  \n",
       "2  https://doi.org/10.47923/2024.15312      Climate & Energy  \n",
       "3  https://doi.org/10.47923/2024.15312      Climate & Energy  \n",
       "4  https://doi.org/10.47923/2023.15274  Clean Transportation  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ucs_program_data = pd.read_csv('UCS_DOIs_and_Programs.csv') #Open CSV that contains Presto data on DOIs\n",
    "\n",
    "ucs_program_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "69f46e58",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-5-4d666289204f>:6: UserWarning: DataFrame columns are not unique, some columns will be omitted.\n",
      "  program_dict = program_list.set_index('DOI').transpose().to_dict() #Transpose the dataframe and make it into a dictionary (currently producing nested dictionaries; fix!!)\n"
     ]
    }
   ],
   "source": [
    "for ind in ucs_program_data.index: #Replace URL-format DOIs with just the numbers so they can be compared to the Overton data\n",
    "    ucs_program_data.loc[ind, 'DOI'] = ucs_program_data.loc[ind, 'DOI'].replace('https://doi.org/','').replace('http://','').replace('dx.doi.org/','')\n",
    "    \n",
    "program_list = ucs_program_data[['DOI','Program']] #Make a new dataframe of DOIs and programs\n",
    "\n",
    "program_dict = program_list.set_index('DOI').transpose().to_dict() #Transpose the dataframe and make it into a dictionary (currently producing nested dictionaries; fix!!)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "49c7c7cf",
   "metadata": {},
   "source": [
    "# Adding more data\n",
    "## UCS Program info\n",
    "The next section of code is designed to add the associated UCS program(s) to the data from Overton. However, we don't have DOI data for every publication in Presto, so we can't get the programs for those. The current try/except block doesn't quite handle it yet."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f73d031d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\pandas\\core\\indexing.py:1684: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self.obj[key] = infer_fill_value(value)\n",
      "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\pandas\\core\\indexing.py:1817: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self._setitem_single_column(loc, value, pi)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10.1111/j.1467-9523.2006.00305.x : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1038/s41558-019-0620-8 : Climate & Energy\n",
      "10.1002/hec.4133 : Food & Environment\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1126/sciadv.aau4373 : Executive\n",
      "10.1111/j.1467-9523.2006.00305.x : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1126/sciadv.aau4373 : Executive\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1016/j.jneb.2017.06.005 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.2136/sssaj2017.03.0077 : Food & Environment | Science Fellows\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1002/hec.4133 : Food & Environment\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1080/08929882.2020.1864945 : Global Security Program\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1080/01402390.2011.623873 : Global Security Program\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1289/ehp.1306693 : Science Fellows\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1080/00963402.2006.11460986 : Global Security Program\n",
      "10.1016/j.jneb.2017.06.005 : Food & Environment\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1016/j.tej.2016.07.001 : Climate & Energy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1126/science.aaw9460 : Center for Science and Democracy\n",
      "10.1080/10962247.2020.1735575 : Center for Science and Democracy | Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1098/rsta.2016.0459 : Climate & Energy\n",
      "10.1093/advances/nmaa026 : Food & Environment\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1080/08929882.2020.1864945 : Global Security Program\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1080/21683565.2017.1326073 : Food & Environment\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1371/journal.pone.0271026 : Center for Science and Democracy | Climate & Energy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1080/08929882.2020.1864945 : Global Security Program\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1016/j.jneb.2017.06.005 : Food & Environment\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1111/josh.12896 : Food & Environment\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1126/sciadv.aau4373 : Executive\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1093/advances/nmaa026 : Food & Environment\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.2136/sssaj2017.03.0077 : Food & Environment | Science Fellows\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1080/21683565.2017.1330795 : Food & Environment | Science Fellows\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.2136/sssaj2017.03.0077 : Food & Environment | Science Fellows\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1088/1748-9326/7/4/045803 : Climate & Energy\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1088/1748-9326/8/4/045004 : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1089/env.2021.0030 : Center for Science and Democracy\n",
      "10.1126/science.aab2939 : Center for Science and Democracy\n",
      "10.1126/science.aaw9460 : Center for Science and Democracy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.4155/cmt.13.47 : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.4155/cmt.13.47 : Climate & Energy\n",
      "10.2136/sssaj2017.03.0077 : Food & Environment | Science Fellows\n",
      "10.1080/21683565.2017.1330795 : Food & Environment | Science Fellows\n",
      "10.1093/advances/nmaa026 : Food & Environment\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1126/science.abg0533 : Center for Science and Democracy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1007/s40518-015-0033-x : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1089/env.2021.0030 : Center for Science and Democracy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1080/10962247.2020.1735575 : Center for Science and Democracy | Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.5304/jafscd.2020.092.009 : Food & Environment | Science Fellows\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1080/01402390.2011.623873 : Global Security Program\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.1038/s41467-023-39363-y : Climate & Energy | Western States\n",
      "10.1126/sciadv.aau4373 : Executive\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1126/science.aab2939 : Center for Science and Democracy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1371/journal.pone.0271026 : Center for Science and Democracy | Climate & Energy\n",
      "10.5304/jafscd.2020.092.009 : Food & Environment | Science Fellows\n",
      "10.1371/journal.pone.0170949 : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1080/08929882.2020.1864945 : Global Security Program\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1371/journal.pone.0271026 : Center for Science and Democracy | Climate & Energy\n",
      "10.1002/hec.4133 : Food & Environment\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1371/journal.pone.0271026 : Center for Science and Democracy | Climate & Energy\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1371/journal.pone.0231929 : Center for Science and Democracy\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1088/1748-9326/ac7ed9 : Climate & Energy\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1088/1748-9326/ab5abc : Climate & Energy\n",
      "10.1111/j.1467-9523.2006.00305.x : Climate & Energy (formerly Global Environmental Program)\n",
      "10.2136/sssaj2017.03.0077 : Food & Environment | Science Fellows\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1007/s10584-017-1978-0 : Climate & Energy\n",
      "10.1111/gcb.13896 : Food & Environment\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1080/08929882.2020.1864945 : Global Security Program\n",
      "10.1057/s41271-021-00318-6 : Center for Science and Democracy\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1038/nclimate2488 : Climate & Energy\n",
      "10.1088/1748-9326/4/2/024001 : Clean Transportation (formerly Clean Vehicles)\n",
      "10.1057/s41271-022-00390-6 : Center for Science and Democracy\n",
      "10.1002/hec.4133 : Food & Environment\n",
      "10.1525/elementa.234 : Climate & Energy\n",
      "10.1371/journal.pone.0271026 : Center for Science and Democracy | Climate & Energy\n",
      "10.3389/fclim.2021.717554 : Climate & Energy\n",
      "10.1088/1748-9326/acbce8 : Climate & Energy\n",
      "10.1080/17583004.2019.1633231 : Food & Environment\n",
      "10.1088/1748-9326/8/1/015004 : Climate & Energy\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10.1088/2515-7620/ab27cf : Climate & Energy\n",
      "10.1371/journal.pone.0215702 : Food & Environment | Science Fellows\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "10.1021/acs.est.0c07030 : Clean Transportation (formerly Clean Vehicles) | Science Fellows\n",
      "10.1016/j.agsy.2018.02.003 : Food & Environment\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1146/annurev.energy.30.050504.144352 : Climate & Energy (formerly Global Environmental Program)\n",
      "10.1038/s41558-020-0804-2 : Climate & Energy\n",
      "FAILED DOIS\n",
      "10.1002/joc.3964\n",
      "10.1016/j.envsci.2006.08.009\n",
      "10.1088/1748-9326/7/2/024023\n",
      "10.1080/08929889308426394\n",
      "10.1007/s11027-007-9138-x\n",
      "10.1111/conl.12190\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1029/2022ef002940\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1007/s10584-015-1472-5\n",
      "10.2139/ssrn.3911532\n",
      "10.1016/s0959-3780(00)00017-0\n",
      "10.1016/j.gloenvcha.2005.04.003\n",
      "10.1371/journal.pone.0091841\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1016/j.envsci.2006.11.002\n",
      "10.1016/j.envsci.2006.12.004\n",
      "10.1016/j.envsci.2006.11.002\n",
      "10.1016/j.envsci.2006.12.004\n",
      "10.1111/conl.12190\n",
      "10.1111/faf.12037\n",
      "10.1371/journal.pone.0098995\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1016/s0301-4215(97)00150-x\n",
      "10.1016/s0301-4215(97)00150-x\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.2307/3868440\n",
      "10.1007/s10584-007-9352-2\n",
      "10.1111/conl.12190\n",
      "10.1038/nclimate2148\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1111/conl.12190\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.5304/jafscd.2013.034.003\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1038/nclimate2081\n",
      "10.1016/j.tej.2021.107002\n",
      "10.1016/j.oneear.2020.07.015\n",
      "10.1016/j.cub.2009.10.001\n",
      "10.1016/j.marpol.2016.07.032\n",
      "10.1371/journal.pone.0075932\n",
      "10.1016/j.cub.2009.10.001\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1371/journal.pone.0117863\n",
      "10.1371/journal.pone.0058799\n",
      "10.1289/ehp.10327\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1080/08929880902864376\n",
      "10.1080/08929880902864376\n",
      "10.1126/science.1136163\n",
      "10.1089/env.2021.0005\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1080/08929880903368690\n",
      "10.1039/c2ee24183h\n",
      "10.1038/nclimate2081\n",
      "10.1088/1748-9326/7/2/024023\n",
      "10.1016/j.gloenvcha.2005.04.003\n",
      "10.1080/08929880902864376\n",
      "10.1007/s10584-007-9359-8\n",
      "10.1007/s10584-007-9359-8\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1088/1748-9326/7/4/045804\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1038/nclimate2148\n",
      "10.1126/science.1136163\n",
      "10.1126/science.1136163\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1126/science.1136163\n",
      "10.1088/1748-9326/7/2/024023\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1007/978-3-319-20161-0_19\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1016/s0013-9351(87)80064-6\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1088/1748-9326/7/4/045804\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1080/08929889808426465\n",
      "10.1525/elementa.356\n",
      "10.1016/j.forpol.2017.08.009\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1080/08929889208426380\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1080/08929880902864376\n",
      "10.1080/08929880902864376\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1007/s10584-007-9352-2\n",
      "10.1016/j.forpol.2017.08.009\n",
      "10.1016/s0959-3780(00)00017-0\n",
      "10.1177/194008291300600308\n",
      "10.1177/194008291300600308\n",
      "10.1289/ehp.10327\n",
      "10.1016/j.envsci.2006.08.009\n",
      "10.1016/s0013-9351(87)80064-6\n",
      "10.1016/j.gloenvcha.2012.12.011\n",
      "10.1080/08929889208426380\n",
      "10.2307/3325286\n",
      "10.1080/08929880309007\n",
      "10.2139/ssrn.3911532\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1007/s10584-015-1474-3\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1038/s41370-021-00375-9\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1525/elementa.297\n",
      "10.1038/s41893-020-0497-6\n",
      "10.1038/nclimate2148\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1016/j.trd.2020.102287\n",
      "10.1017/s1742170517000588\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1525/elementa.356\n",
      "10.1371/journal.pone.0159668\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1007/978-3-319-20161-0_19\n",
      "10.1080/21683565.2017.1331179\n",
      "10.1111/conl.12190\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1038/nclimate2081\n",
      "10.1088/1748-9326/7/2/024023\n",
      "10.1371/journal.pbio.1000331\n",
      "10.1126/science.1136163\n",
      "10.1016/j.trd.2020.102287\n",
      "10.1080/08929889308426394\n",
      "10.1016/s0301-4215(97)00150-x\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.2139/ssrn.3911532\n",
      "10.1016/s0959-3780(00)00017-0\n",
      "10.1289/ehp11750\n",
      "10.1126/sciadv.aau4373?cookieset=1\n",
      "10.1007/s10584-007-9359-8\n",
      "10.1007/s10584-007-9352-2\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1126/science.aam5733\n",
      "10.1111/conl.12190\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1177/0361198119836971\n",
      "10.1038/nclimate2081\n",
      "10.1111/conl.12190\n",
      "10.1126/science.1136163\n",
      "10.1371/journal.pone.0075932\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1007/s10584-014-1127-y\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1101/2020.08.07.20170555\n",
      "10.1111/conl.12190\n",
      "10.1093/jas/skz258.302\n",
      "10.1080/08929880902864376\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1080/08929889308426394\n",
      "10.1080/08929889308426394\n",
      "10.1016/j.envsci.2006.08.009\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1175/jcli-d-14-00808.1\n",
      "10.1289/ehp.10327\n",
      "10.1088/1748-9326/8/1/015001\n",
      "10.1080/08929889208426380\n",
      "10.1142/s2382624x23400039\n",
      "10.1038/s41370-021-00375-9\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1017/s1742170517000588\n",
      "10.1016/j.tej.2021.107002\n",
      "10.1017/s1742170517000588\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1126/science.1136163\n",
      "10.1371/journal.pone.0091841\n",
      "10.1371/journal.pone.0058799\n",
      "10.1525/elementa.356\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1017/s1742170517000588\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1080/10549811.2015.1031909\n",
      "10.1016/j.envsci.2006.08.009\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1080/08929880903368690\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1016/j.tej.2021.107002\n",
      "10.1088/1748-9326/8/3/035006\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1088/1748-9326/8/3/035006\n",
      "10.1038/nature21906\n",
      "10.1088/1748-9326/7/4/045804\n",
      "10.1088/1748-9326/8/3/035006\n",
      "10.1007/s10584-007-9352-2\n",
      "10.1029/2007wr006159\n",
      "10.1177/194008291300600308\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1177/194008291300600308\n",
      "10.1371/journal.pbio.1000331\n",
      "10.1371/journal.pbio.1000331\n",
      "10.1017/s1742170517000588\n",
      "10.1038/nclimate2081\n",
      "10.1525/elementa.211\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1080/21683565.2017.1331179\n",
      "10.1017/s1742170517000096\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1080/08929889308426394\n",
      "10.1080/00963402.2003.11460678\n",
      "10.1080/08929880490464775\n",
      "10.1371/journal.pbio.1000331\n",
      "10.1177/194008291300600308\n",
      "10.1038/nclimate2148\n",
      "10.1038/nclimate2081\n",
      "10.1126/science.1136163\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1007/s10584-015-1474-3\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1038/361293a0\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1089/env.2021.0005\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1126/science.aam5733\n",
      "10.1080/08929880902864376\n",
      "10.1088/1748-9326/11/7/074006\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1007/978-3-319-20161-0_19\n",
      "10.1525/elementa.297\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1080/08929880490464775\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1126/science.aam5733\n",
      "10.1002/essoar.10507713.1\n",
      "10.1177/0361198119836971\n",
      "10.1007/978-3-319-20161-0_19\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1038/s41370-021-00375-9\n",
      "10.1007/978-3-319-20161-0_19\n",
      "10.1007/s10584-020-02882-4\n",
      "10.1088/1748-9326/8/3/035006\n",
      "10.1525/elementa.356\n",
      "10.1016/j.envsci.2006.12.004\n",
      "10.1080/08929889208426380\n",
      "10.1525/elementa.211\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1080/21683565.2017.1331179\n",
      "10.1016/j.oneear.2020.07.015\n",
      "10.4271/2002-01-1900\n",
      "10.1088/1748-9326/8/3/035046\n",
      "10.1080/08929880902864376\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1007/s10584-015-1474-3\n",
      "10.1080/08929880902864376\n",
      "10.1016/s1469-3062(03)00028-7\n",
      "10.1029/2022ef002928\n",
      "10.1029/2022ef002928\n",
      "10.1371/journal.pone.0159668\n",
      "10.1080/08929889308426394\n",
      "10.1007/s10584-011-0136-3\n",
      "10.1080/08929880903368690\n",
      "10.1016/j.tej.2021.107002\n",
      "10.1089/env.2021.0005\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1126/science.aam5733\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1038/s41893-020-0497-6\n",
      "10.1038/nclimate2148\n",
      "10.1890/090143\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1007/s10584-015-1474-3\n",
      "10.1007/s10584-011-0194-6\n",
      "10.1126/science.1136163\n",
      "10.1007/s10584-014-1127-y\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1371/journal.pbio.1000331\n",
      "10.1038/nclimate2148\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1021/acs.est.0c07030?ref=pdf\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1016/s0959-3780(00)00017-0\n",
      "10.1029/2022ef002940\n",
      "10.1089/env.2021.0005\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.1007/s10584-007-9352-2\n",
      "10.2105/ajph.2022.307085\n",
      "10.1890/1540-9295(2005)003[0012:ispmaf]2.0.co;2\n",
      "10.1016/j.apenergy.2021.117309\n",
      "10.1016/s0959-3780(00)00017-0\n",
      "10.1016/j.jneb.2015.03.005\n",
      "10.1289/ehp12503\n",
      "10.1080/08929889308426394\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1080/25751654.2021.1994744\n",
      "10.1080/25751654.2021.1994744\n",
      "10.2968/062003010\n",
      "10.1016/j.jneb.2017.05.178\n",
      "10.1029/2022ef002928\n",
      "10.1016/j.envsci.2021.04.014\n",
      "10.2139/ssrn.2627462\n",
      "10.1029/2022ef002940\n",
      "10.1177/194008291300600308\n",
      "10.1007/s10584-015-1472-5\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1029/2022ef002928\n",
      "10.1029/2022ef002928\n",
      "10.1007/s10584-015-1474-3\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1016/j.apenergy.2015.10.180\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1289/ehp11750\n",
      "10.1080/08929880490464775\n",
      "10.1080/08929889308426394\n",
      "10.1080/17583004.2023.2288592\n",
      "10.1111/conl.12190\n",
      "10.1371/journal.pone.0079889\n",
      "10.1080/08929880902864376\n",
      "10.1080/08929880902864376\n",
      "10.3389/fsufs.2021.794594\n",
      "10.1016/j.envsci.2015.09.013\n",
      "10.1038/s41370-021-00375-9\n",
      "10.1038/474s017a\n",
      "10.1007/s11625-014-0269-1\n",
      "10.1371/journal.pone.0058799\n",
      "10.1007/s10584-015-1403-5\n",
      "10.1016/j.gloenvcha.2012.12.011\n"
     ]
    }
   ],
   "source": [
    "#This adds the UCS program to each entry in the ucs_cites dataframe\n",
    "#But there seems to be a lot of DOIs that are not in Presto (but appear to be from UCS authors?)\n",
    "#How to get program data for these?\n",
    "failed_doi = [] #list of DOIs that don't match up\n",
    "\n",
    "for ind in ucs_cites.index:\n",
    "    try:\n",
    "        doi = ucs_cites.loc[ind, 'Cited identifier']\n",
    "        program = program_dict[ucs_cites.loc[ind, 'Cited identifier']]['Program']\n",
    "        print(doi, ':', program)\n",
    "        ucs_cites.loc[ind, 'Program'] = program\n",
    "    except:\n",
    "        ucs_cites.loc[ind, 'Program'] = 'No citation data'\n",
    "        failed_doi.append(ucs_cites.loc[ind, 'Cited identifier'])\n",
    "        \n",
    "print('FAILED DOIS')\n",
    "for item in failed_doi:\n",
    "    print(item)\n",
    "    \n",
    "ucs_cites.to_csv('UCS-cites-in-overton.csv') #Save filtered/annotated dataframe to CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "758cb7b7",
   "metadata": {},
   "outputs": [],
   "source": [
    "#citers = list(set(ucs_cites['Source of citing document'].to_list()))\n",
    "citer_counts = ucs_cites['Source of citing document'].value_counts()\n",
    "#citing_articles = list(set(ucs_cites['Title of citing document'].to_list()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5a0dd18d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#df_citers = pd.DataFrame({'Citing body':citers})\n",
    "\n",
    "citer_counts.to_csv('citers.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "053801fb",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
